70 Spencer Gardens Rochford Essex SS4 1TW 17 March, 1996 README.TXT ============ This document contains information about installing and using the Print Selection Add-In for Microsoft Excel v5 and v7. History ------- The idea for the Print Selection Add-In came to me whilst I was writing a Spreadsheet to colate and calculate manpower costs at different labour rates The problem "Print Selection" overcomes is not being able to print non-contiguous ranges of cells to a single sheet. This can be illustrated as follows:- +------+----------+----------+----------+----------+----------+----------+ | Code | 01/01/95 | 08/01/95 | 15/01/95 | 22/01/95 | 29/01/95 | 05/02/95 | +------+----------+----------+----------+----------+----------+----------+ | 111 | £1.00 | | | | | | | 222 | | £2.00 | | | £2.00 | | | 333 | | £3.00 | | £2.00 | £2.00 | | | 444 | | | £2.00 | | | £1.50 | | 555 | | | | £2.00 | | £3.50 | | 666 | | | | | | | +------+----------+----------+----------+----------+----------+----------+ Suppose you wanted a printout of the above table for the week 15/01/95 and week 22/01/95 but you want the code column to cross reference to! If you select the columns in question and then use the normal Excel print command, the code column prints on a sepperate sheet!, not very useful! "Print Selection" overcomes this problem. History ------- Version 1.0 - Not a public issue. Version 1.1 - Public Release late 1995 Made user friendly. Version 1.2 - Released March 1996 Bug Fix - did not correctly copy cells if they were resized. Bug Fix - A number of Excelv7 Problems caused by subtle changes in the Excel code. Added on-line registration feature, allowing user to disable the Nag-Screen. Installation ------------ The installation process is detailed below. It is the same for both Excel v5 and Excelv7 1) Open Microsoft Excel. 2) Create a New borkbook. 3) From the "Tools" Menu select "Add-Ins..." 4) Select "Browse..." 5) Locate the file "PRINTSEL.XLA" and press "OK" 6) Select "Yes" to copy the Add-In to Library Using "Print Selection" ----------------------- Print Selection has been written to be seamless to the user. There have been no menu additions to activate the command. The "File" "Print..." command has been redirected. To show it working, create a spreadsheet with a few cells completed. e.g. Put "A" in cell A1, "B" in cell B1 etc and copy down a few lines. Select cell A1 only, Select "Print...", the normal print dialog should appear. Press "Cancel". Select cells A1:A3 then press Ctrl whilst selecting cells C1:C3. This is a non-contiguous range. Select "Print...", the "Print Selection" dialog box should appear. Registration ------------ If you like "Print Selection" and intend to use it, please register it, All it will cost you is £5.00 Stirling. See REGISTER.TXT for more information. Registered Users are entitled to six months unlimited eMail support and will automatically receive any major bug fixes during this period. Registered users will recieve a registration number which will allow them to disable the opening and closing nag screens (The about box showing when the add-in is opened and closed). The Registration Numbers will be eMailed to the user on receipt of the registration fee. If you would like to register this via CompuServe the program ID is 10007 Unfortunately CompuServe's Minimum Software Cost is $10 To use this option GO SWREG and follow the prompts. Thank you for reading this far!! I hope it will be as much use to you as it is to me, Please send me any comments or suggestions on improvements. Simon Daykin 70 Spencer Gardens Rochford Essex SS4 1TW England eMail :- 100661.3533@compuserve.com Web Page :- http://ourworld.compuserve.com/homepages/Simon_Daykin/ ------------------------------ End of Document ------------------------------